﻿CREATE TABLE [dbo].[AngajatiPontaj] (
    [IdPontaj]            INT             IDENTITY (1, 1) NOT NULL,
    [Valoare]             INT             NULL,
    [IdPersoana]          INT             NOT NULL,
    [IdTipPrezenta]       SMALLINT        NOT NULL,
    [IdAngajatSalarizare] INT             NOT NULL,
    [DataDefinire]        DATETIME        NOT NULL,
    [SalarUnitar]         DECIMAL (18, 2) NOT NULL,
    [Luna]                SMALLINT        CONSTRAINT [DF_Pontaj_Luna] DEFAULT ((0)) NOT NULL,
    [Anul]                SMALLINT        CONSTRAINT [DF_Pontaj_Anul] DEFAULT ((0)) NOT NULL,
    CONSTRAINT [PK_Pontaj] PRIMARY KEY CLUSTERED ([IdPontaj] ASC),
    CONSTRAINT [FK_AngajatiPontaj_AngajatiSalarizare] FOREIGN KEY ([IdAngajatSalarizare]) REFERENCES [dbo].[AngajatiSalarizare] ([IDAngajatSalarizare]),
    CONSTRAINT [FK_Pontaj_Persoane] FOREIGN KEY ([IdPersoana]) REFERENCES [dbo].[Persoane] ([IdPersoana])
);

